2. Data Preparation

Load and Combine Monthly Data

2.1 Check and Clean the Data

Check for Missing Values

Remove Missing Values

Ensure Proper Date/Time Format

Remove Duplicate Records

2.2 Add New Calculated Columns

Trip Duration

Day of Week

Hour of the Day

3. Analyze the Data

3.1 Aggregate Metrics by User Type

Total Number of Rides by User Type

User Type Total Rides
member 3739923
casual 2159006

Average Trip Duration by User Type

User Type Average Duration (minutes)
member 12.23080
casual 21.09462

3.2 Analyze Usage Patterns

Peak Hours by User Type

Peak Hours of the Day for Members (Average Rides)
Hour of Day User Type Total Rides
17 member 296091
16 member 256493
18 member 220849
8 member 194853
15 member 184861
7 member 157949
19 member 152854
14 member 150207
12 member 150041
13 member 149468
11 member 131538
9 member 128391
Peak Hours of the Day for Casual Riders (Average Rides)
Hour of Day User Type Total Rides
17 casual 147297
16 casual 139583
15 casual 123407
18 casual 121586
14 casual 113113
13 casual 109257
12 casual 105396
11 casual 90073
19 casual 87446
10 casual 70819
20 casual 63083
9 casual 55560

4. Visualize Insights

5. Summarize and Recommendations

Key Findings

  • Usage Trends: Members take more rides overall but have shorter trip durations on average.
  • Casual Riders: Ride primarily on weekends and during leisure hours.
  • Members: Use bikes more consistently across the week, especially during commute hours.

Recommendations

  • Design weekend promotions targeting casual riders.
  • Highlight the benefits of annual memberships for regular commuting needs.
  • Increase marketing efforts at popular casual rider stations to convert them to members.